USE [CMS]
GO

/****** Object:  View [dbo].[VW_Permissions]    Script Date: 01/01/2013 14:05:09 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[VW_Permissions]
AS
SELECT     dbo.Permissions.ADM_ID, dbo.Permissions.PERM_ID, dbo.Permissions.USR_ID, dbo.Permissions.USR, dbo.Permissions.UPL, dbo.Permissions.PAG, dbo.Permissions.PERM_NAME, 
                      dbo.Users.USR_NAME, dbo.Permissions.HRS
FROM         dbo.Permissions LEFT OUTER JOIN
                      dbo.Users ON dbo.Permissions.USR_ID = dbo.Users.USR_ID

GO
